SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043210 LIMIT 1 [ RunTime:0.002251s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043210 [ RunTime:0.002218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273755,790570,1008879,456894,906413,894440,599412,837838,118506,976317,529481,662853,220799,94992,891463,599540,1038702,179118,226528,66556,593488,200475,723495,395309,23556,656483,1022683,151746,607284,936491,694707,367899,560824,350660,789767,18749,801819,480083,1046182,950768,405821,994640,440942,658259,901864,656334,1044961,785752,94146,142480,801618,869658,1043378,493069,856131,845473,212085,397124,938970,992961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]