SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545329 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545329 [ RunTime:0.002527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583749,418686,580793,509468,934439,476426,901420,915521,922270,332490,1010020,797138,988776,12960,156761,831040,261733,319303,798240,105056,946374,205795,560960,868871,662959,904430,831255,234223,985008,730254,84683,676223,297246,242886,594892,989404,305955,352804,748296,842061,439,897385,1939,215109,382104,592822,288258,643245,908069,18948,1041304,636522,32518,629649,273650,129295,880380,490734,564264,377152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]