SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313516 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313516 [ RunTime:0.002209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259103,316719,324690,219425,679008,247420,817375,673748,392763,169037,954817,675904,781802,66273,353415,44721,421017,931864,291367,193529,58803,594116,472440,670666,580661,805672,955017,44637,896958,222404,963965,1013570,989116,273099,355888,149121,105758,18518,772182,265547,691347,783668,256671,699288,716120,1004421,479512,882058,28340,837466,1040571,69467,911295,326683,513401,713896,939344,422540,631198,623251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]