SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003669s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022283 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022283 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117577,616289,734558,636216,954860,235575,877639,780211,461704,66793,236493,335471,884026,65099,957804,767178,715386,432069,965868,597495,359258,625626,523764,949342,182614,582378,992940,225191,921110,349560,908133,274104,697407,877354,495854,682641,54828,1042465,788961,359021,82612,652247,333532,190689,579589,287298,933190,199414,338242,183844,513480,262436,747184,1002257,158381,1002911,221755,157266,689834,758825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001713s ]