SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484037 LIMIT 1 [ RunTime:0.003231s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484037 [ RunTime:0.003780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119934,936864,1022794,822637,128764,616671,899675,613573,598973,73814,801008,14680,801951,475626,713337,731095,374808,538115,357113,509829,84064,665878,1043621,774985,117418,440587,979855,35682,1021202,984677,710879,338158,360837,363615,502647,727176,144764,1042632,182527,637561,5664,206142,144262,636863,719719,269509,168480,921795,703931,803170,126012,880533,546443,622308,813066,253341,966143,505393,446959,371337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003520s ]