SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003004 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003004 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156630,845368,550843,435161,802733,38452,722344,42407,336614,738375,965928,60884,520091,611721,819550,63323,415721,767440,357366,323304,778112,716531,343076,613242,1033627,521480,553030,182040,887869,839985,290926,1016296,731557,795273,167172,196035,177724,563250,677914,218454,901489,8061,294814,478791,574948,419791,647678,284519,350666,280698,345888,267338,189927,588016,255342,340136,776707,222531,557212,370685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]