SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507114 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507114 [ RunTime:0.002568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805245,890060,366857,996141,306210,374595,270415,324965,958198,297159,643786,1042684,380005,684278,38972,360546,111788,147378,342900,829137,306104,487544,255911,997334,813302,959257,228586,320632,268684,713343,30796,128766,365882,860764,863899,211328,106677,575161,997321,647191,788772,813732,862230,151354,252533,898782,428908,3584,202075,205580,321862,378958,1031337,994770,108798,4610,621099,688235,288510,137428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002867s ]