SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451026 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451026 [ RunTime:0.002803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292696,3273,807184,759402,829399,850392,687721,611694,201500,855564,224167,922733,764402,327235,319376,735304,467869,189101,227781,453159,597951,284698,34592,811631,44411,400959,146458,523985,776830,954870,426865,62105,54644,583554,102517,432045,924208,545358,777880,809130,116394,88431,328409,828224,449523,7892,858858,50907,908285,796960,802172,234655,966617,876145,240372,269390,946460,814764,276723,237115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001027s ]