SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506219 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506219 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634102,9052,149984,764461,852867,385776,823030,414427,670074,465315,125289,543248,128572,979954,915989,273777,845788,48099,425957,737126,568333,305537,319719,593661,223764,118224,87650,619068,673274,123765,870191,516543,158065,717857,768106,7209,964637,374251,726091,201825,103105,365477,551939,620921,435544,1048677,800180,828704,858459,123808,957704,449202,71756,741650,306624,193826,897192,830059,868047,275561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]