SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531497 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531497 [ RunTime:0.002361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617113,327209,51029,977001,976300,681627,797943,217623,217476,270990,858163,673748,383921,140093,983796,30642,381474,631608,169748,425597,315412,577654,503094,130122,311977,1020623,432153,672094,39334,278361,176097,453037,502885,884625,801735,314288,986047,148290,254599,20809,369926,156373,30389,130771,867412,348026,841983,153480,1014338,1039592,553916,548121,345566,296344,565701,999231,286885,112310,748873,309157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531497 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531497 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]