SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534283 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534283 [ RunTime:0.001329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293681,851392,927601,213741,31731,849944,670850,1031316,422065,324285,50436,246221,525602,671958,779593,128975,479964,629964,985643,665478,132788,814695,1033312,961046,595372,554784,477709,776823,1041389,55142,293518,625901,870670,244214,98750,760824,189595,415773,643173,703182,774073,174610,515670,261605,79032,910214,309348,295326,1047351,825056,184045,493235,278688,961452,944995,407868,331800,321239,206264,747016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]