SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002626s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531751 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531751 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997028,726030,544488,209791,812392,752590,561330,350762,894385,896289,10999,445272,674679,500463,923980,222923,598230,313830,1005208,130261,551091,1016557,835891,711898,978568,263466,909029,371731,457955,373694,545878,694144,85282,686956,36170,102480,25139,195814,63619,264227,748242,580854,656705,423078,421167,130535,386938,889888,47353,802400,264578,447924,511674,332002,561483,644188,729197,871528,520058,549863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002795s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000951s ]