SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 337570 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337570 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268795,144535,812967,591358,476058,85197,270758,789744,464708,840593,790314,294796,441843,1035437,980931,1013722,45304,782696,1035224,94,424586,936854,155756,665318,644215,454872,667688,365109,23450,89182,857485,342996,665688,1007718,168502,58748,786602,146331,628674,548303,35687,431402,77386,80636,444841,1044621,344275,16337,670120,108888,1044633,452356,600707,201532,902178,911866,758017,115345,214336,79888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]