SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510401 LIMIT 1 [ RunTime:0.001000s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510401 [ RunTime:0.002502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849696,733059,59150,605082,242111,768248,714660,843077,112023,704090,400473,9293,188768,765093,825249,178238,192371,773315,722142,981688,380676,372458,723475,768953,532479,882681,711656,837781,392828,998662,577588,92182,293330,242760,269135,555288,1043664,416714,869979,602943,516784,297741,886038,365927,527246,532538,704407,71848,838030,57484,849558,286173,151613,353158,620170,359300,768127,850173,808245,737570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]