SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442442 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442442 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310751,689434,207856,745350,432343,739165,510340,617533,26224,757314,151766,234811,591436,194842,1012678,433091,599963,366112,112500,458877,147863,952144,1004536,527694,33849,182407,948265,639349,420504,258085,738870,1023499,1021138,671594,426311,185581,538713,71437,210854,850402,314783,857312,597188,406551,440189,492712,372537,744569,507204,520698,998693,464572,579234,13873,716143,116266,876894,888829,874048,1018883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]