SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 661942 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 661942 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108934,903192,680626,741802,337878,939055,441955,806567,114773,140574,786009,941075,840571,1036120,269130,1042420,313562,125558,147006,565264,1010770,1035203,199457,108509,259740,182133,346199,764018,464349,930896,444729,501160,529513,754830,138670,438278,709420,507344,985686,370342,382310,1009725,538296,220392,35289,292516,523049,453986,1014605,520257,133648,333743,830154,545259,729065,764262,290998,444892,797056,520390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 661942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 661942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]