SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477920 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477920 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847135,783363,866940,725524,787216,1009654,905419,767142,389589,312106,970128,240471,727402,802781,503288,465566,188895,270836,781287,207009,789006,690473,582938,647281,160613,99111,174746,207361,747884,385220,951453,837853,103096,350777,506061,136100,594836,334738,654349,833579,311583,271352,73060,439200,1036180,16211,496053,175140,509307,93085,417797,6928,313348,803825,44330,24388,717361,608547,176077,968670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001271s ]