SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001845s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002094 LIMIT 1 [ RunTime:0.000623s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002094 [ RunTime:0.003729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497278,275329,504747,294180,481949,328613,478303,720582,989872,441850,25336,601911,608687,471001,1002771,757394,989643,791450,4794,805585,434483,632506,861905,795095,375601,810629,907998,721196,92162,127722,76708,976726,252918,777115,561103,284456,1020257,907774,369842,227125,568446,540938,325614,845148,947989,739517,1030014,156562,260367,358464,322312,417907,524788,686141,218071,1027004,634646,708269,427813,52499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]