SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315986 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315986 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710820,412647,1000825,336417,398983,77357,94120,1016780,516911,557341,1033779,568229,26080,751269,602154,806271,450870,464898,111089,484894,897575,410596,412271,138792,370193,610112,282924,382500,151511,133442,632916,521826,960032,156335,72302,393487,313074,279056,758181,603282,1034646,586638,228580,177902,540817,53130,129043,586140,195317,906983,541841,180789,946312,579371,813433,1005893,377764,433526,1040990,285191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]