SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108954 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108954 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022419,99011,59679,562373,10401,1032991,877567,530131,195939,431959,508419,776063,153759,494893,217100,699998,155749,303697,789848,291889,921285,4562,567019,333136,136139,967202,257449,595515,968049,570488,1028823,602463,133831,894988,893710,371949,709745,1043003,944115,994974,612805,20042,451714,259283,743487,888806,499333,673444,281740,756701,276941,767462,661068,206539,795574,752722,22552,816095,678727,472952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]