SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480514 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480514 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925985,667323,272204,690895,437488,45699,471950,154145,303593,433499,467152,485526,579600,848721,157994,460279,614994,989198,503708,100916,707141,66436,610031,374517,133535,228850,458561,21029,814169,293917,61712,994527,307059,1043091,180843,627817,749125,707032,645147,921964,311934,367593,670700,1022687,198623,314848,965593,515243,634700,329806,313695,266509,721956,862955,887162,710638,746784,387452,121317,332413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]