SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6872 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6872 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906772,977976,268817,896702,4674,143580,624913,238180,1033702,876466,366696,891161,1007028,865800,882510,941602,1033022,878884,925776,116380,1039307,621525,530684,518390,201109,1035276,438832,172181,32836,570688,1034442,479386,158312,466609,143204,187725,578614,386194,559998,872381,131016,762515,859142,117880,541665,431197,793904,384848,381447,819098,912372,342344,284783,1021949,172706,1025048,689864,608381,474449,508121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]