SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 884410 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 884410 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046193,1042890,806674,747626,872144,404670,717034,495486,911044,443876,241279,532853,307583,12724,67841,97969,457652,480395,775439,687926,333346,476363,656708,227184,15779,1043798,902788,684498,339455,263704,620170,880401,451112,963288,234261,264302,644302,261108,579572,789943,941058,595151,413846,944818,366142,497093,378443,468682,125731,446942,805797,457087,930834,679863,545722,720625,1004291,385038,22819,22086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 884410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 884410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]