SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447118 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447118 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909866,885728,123449,265870,201679,274343,559430,603057,487763,297807,599061,627691,518284,220975,971423,1035327,51285,46247,323976,95578,733467,137017,847587,940346,608207,75765,267419,656970,848096,1012846,287037,162157,159506,454857,37534,29393,637820,826678,668856,67382,32069,30282,553349,285776,971617,143330,380307,346749,890703,931350,457191,622480,801153,501915,690799,585849,6011,946394,94014,717068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]