SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44912 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44912 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752902,1039920,817442,869929,595173,963574,753691,589528,117963,657402,168427,384434,223020,612429,745224,255832,278583,254622,196352,1003200,362729,237256,283987,238684,955623,458941,872162,516619,413141,14437,711118,761836,417669,110710,36669,276167,241032,724464,19307,106630,604215,760596,459953,156032,399861,1046987,1016190,1005696,988464,629283,941912,864391,573806,1035336,100404,926803,768683,92012,228293,713567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]