SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596728 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596728 [ RunTime:0.003708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777244,188252,799168,391739,479179,531862,285236,893713,752529,296787,63322,991254,496762,167893,781543,682866,75977,86733,240347,90527,1007098,605161,577717,90446,630510,410696,1042535,157257,493660,443568,833926,972370,924049,275398,940622,38922,960223,536690,714927,787706,15689,99016,791205,707542,332096,134748,379866,41615,987000,88957,766787,982870,280599,849519,892161,1029819,827128,919825,383080,192323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]