SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317151 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317151 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310024,119762,70005,44557,1008854,1000572,105783,733842,507853,34195,356363,1022557,942630,219091,429201,822387,195539,734826,872736,108039,802156,897943,381872,270482,855508,1048475,369836,705341,628391,769827,419538,79887,349358,822318,405041,127154,689817,265241,196620,159775,179977,479366,774345,1018618,360297,784110,601324,837106,120888,944221,109317,509280,518890,925955,426100,1004046,170149,53279,223032,280730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]