SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471966 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471966 [ RunTime:0.002705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511847,845800,548792,413107,854693,964816,442453,214909,576187,95854,233068,833244,482921,63722,499824,438051,268786,255310,954069,439699,397571,822423,966457,853085,157658,63355,246214,48573,670925,575545,118120,857201,694018,391501,63203,553887,871570,384855,532944,575326,176624,476342,554898,222,24277,298281,537048,273728,712316,532456,927680,692492,615784,466054,1006937,355544,638550,487826,616090,148932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]