SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557196 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557196 [ RunTime:0.003064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504679,315659,371459,367130,895733,641308,283116,857394,1016311,107259,851696,8574,279345,286259,604564,708811,933410,187437,64160,373813,513601,139728,380340,164655,604934,425023,679031,986323,496275,442061,290339,458828,506253,211643,565343,426438,860915,159010,632290,425138,1038866,11287,72329,662624,338564,316547,467423,1018514,311395,321787,981667,318345,854351,404739,947939,872573,214945,850570,999276,118303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]