SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002073s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 614218 LIMIT 1 [ RunTime:0.001694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 614218 [ RunTime:0.002405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520858,486407,829016,434156,875557,20072,637014,981623,419821,5333,804472,595908,27546,250086,943638,961445,23464,47448,522674,509794,597939,156527,246616,951746,295068,411589,240139,973401,474202,262787,733399,389871,305809,430886,939636,374988,448382,974660,798162,388953,320463,634786,1022398,840914,194364,59137,1003403,674088,582452,351373,524066,420048,69183,124055,721793,696622,779026,404158,90007,262720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 614218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 614218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001311s ]