SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54776 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54776 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940499,771715,76516,547242,241631,825173,840558,95841,856892,568864,519964,73004,723477,175736,958000,267734,241926,178877,88231,501714,1006037,628440,214424,881033,529305,940713,1003355,392712,407803,584094,120222,1002927,567138,468399,910950,683552,603449,569167,437768,381306,95391,367102,452576,610990,343011,240802,365211,684038,227352,1045829,905519,295611,1007851,1038724,900230,899967,777591,584335,981653,670173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]