SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022593 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022593 [ RunTime:0.003309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699598,278045,16119,149356,995112,382443,871957,138455,640016,929671,235218,313514,384930,542488,905259,660107,736716,200779,429291,853869,100002,301539,271612,991170,415175,288473,1021467,259924,232850,275409,819609,91729,850170,979702,154292,441785,53862,222138,713019,438213,992682,742388,148812,606879,650746,889299,297877,763507,475097,51145,509137,24075,174414,651876,734764,359219,82420,569197,400683,808313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001925s ]