SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914811 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914811 [ RunTime:0.002133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233188,220047,217535,94808,518342,520478,196263,702148,417113,381408,652013,150692,122109,680033,895007,278059,775565,15520,711228,939173,515594,531662,52808,958072,329078,1000953,312013,998788,223802,355138,470962,836513,646979,777502,435516,506692,390968,652044,602582,936762,510016,291795,332182,639078,417841,45293,943105,859236,1014978,558139,234397,95442,910852,1034170,839678,518094,487919,662572,367923,682274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002096s ]