SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001826s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198496 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198496 [ RunTime:0.002904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672019,521940,40560,541867,388181,325814,325866,126171,175452,528373,16592,858631,336665,177915,317758,351599,468261,1036700,255011,306210,185558,253528,901683,92416,64918,841240,1043619,14790,598266,684822,767478,544460,172283,339024,586072,392488,636257,318837,804517,1038081,589668,890853,861563,247342,421613,715260,614589,798893,422722,828598,209353,64872,853941,850626,740796,800403,1021064,152277,22299,1026416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]