SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 714396 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 714396 [ RunTime:0.002625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394215,789414,199214,681775,164836,871176,499726,566289,701845,1043347,728912,385660,109904,499915,256528,85346,722809,423455,192331,563180,1001804,168716,38302,434593,203559,807658,993605,637330,101206,629613,961483,712786,599158,275219,153844,726834,333216,1046733,268273,98504,366424,186267,999662,257658,257420,1040691,238605,97811,442772,780577,471349,396813,991518,686033,541951,749579,1014760,597540,599494,892773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 714396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 714396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]