SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001812s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392918 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392918 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258849,636604,830409,461602,618765,945537,1023146,1033938,1019892,560846,564011,399843,942539,207201,408080,268443,904523,226203,453651,954706,458295,883219,209698,1030275,915367,257997,113432,429274,541764,900375,993718,209954,954934,284696,261488,46019,151993,132677,216947,687398,599332,68553,243410,765055,113678,404196,493755,319143,701230,1007962,76653,294946,543890,997216,911934,698375,248302,70838,890707,28638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001760s ]