SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531514 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531514 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352838,346487,438123,208739,965956,911364,666117,396356,249975,790277,1010692,721743,505097,101893,598045,744958,360411,49878,424366,791687,418392,882096,871288,137870,845420,38461,254830,124499,656854,69906,595362,504850,859437,698730,563546,40006,966350,594378,390712,712470,155267,710871,569400,831289,217830,795475,382720,396462,360998,1023943,722666,629486,733468,971370,344437,834705,909644,1041908,659079,667394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]