SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 84495 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 84495 [ RunTime:0.002572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410020,640679,718312,194921,557120,397190,583194,855814,248662,460400,687844,798728,317882,418496,1781,402569,526224,147570,1025311,116783,644917,756617,652456,352863,331826,373709,46169,596673,160140,373105,300626,899233,704480,975510,968422,114480,415579,302635,757293,450210,513283,339472,748187,466639,791044,340146,871810,287514,744615,740341,632255,945238,447693,125916,539201,967176,383749,489849,1026196,766446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 84495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 84495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]