SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505900 LIMIT 1 [ RunTime:0.003953s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505900 [ RunTime:0.003096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239171,754650,878312,215877,540034,505194,897830,722371,624954,172382,244628,836001,589023,700869,948688,941741,451850,650647,232789,706088,176665,765826,40195,942733,375883,497221,443733,502962,507767,467690,337218,607111,529396,162997,295180,555717,658158,814220,418686,593243,608717,76024,214143,855987,992456,940717,415434,840538,1024509,163188,219056,191473,1034944,441890,303563,1002483,495528,489463,882107,402053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]