SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030943 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030943 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570105,154394,441720,982622,582859,506180,871769,110892,853652,296673,829204,477950,746901,143964,354829,237502,687961,771422,750549,547522,400192,390521,870429,1006148,692431,760025,448070,724061,637515,92142,467935,33557,13740,343569,439547,309478,960010,446715,332803,23374,642280,797637,3573,191519,122811,54729,695195,341174,48360,1025703,853128,835589,1037376,935531,277092,575607,651858,646765,716489,53672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001633s ]