SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116941 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116941 [ RunTime:0.003613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178363,19042,179054,1011967,951475,487194,769075,37533,745861,8253,304455,311857,239518,775499,248814,640553,773105,443759,118121,235631,610040,473926,701070,982812,129204,856450,236229,1020854,122868,497403,860792,1016596,319325,567654,1001411,272801,1039052,524845,813543,531195,651562,230069,992707,418230,497560,549963,457246,30622,10965,72575,773874,1036336,840778,101380,136861,284561,843189,756635,66692,515712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]