SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504916 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504916 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253700,955867,446343,134905,742823,202446,508268,715849,155670,209135,128299,64670,595184,177880,108977,211536,854655,89144,528026,476165,932108,19626,820991,556491,536263,365012,168781,918018,913203,367766,349490,1026165,568589,953803,929294,49851,480366,1039112,744448,192825,845269,243155,111711,986683,591396,700419,1010639,633424,84308,473700,141919,770090,934999,263059,548853,366713,939803,501183,678273,59010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]