SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51686 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51686 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573468,101579,995328,718232,859576,262490,699375,711340,869891,117014,717826,614630,863386,962574,656615,301488,452734,755500,498796,466634,513438,85067,461463,122068,1006216,201845,940667,716650,99731,54772,840968,1025712,306057,992441,533687,669894,712263,309398,500107,145873,562254,319029,11431,250850,6437,435972,707279,594125,22805,852631,200253,238034,948384,742455,875383,1030200,379460,805888,668153,1001545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]