SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518800 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518800 [ RunTime:0.002411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813210,469597,887096,822136,1575,908320,570661,933795,675968,865064,1027100,483576,396439,148851,509737,118223,241976,13580,273358,377500,808776,49625,515074,516187,828862,869631,111319,865225,558788,350353,93644,628765,860477,273027,661515,795728,355751,574965,190002,703844,421267,627579,165687,81227,557845,989422,977318,354336,1034894,463950,1030902,1012002,850293,236851,396292,102158,243916,221288,457752,685988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001312s ]