SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263300 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263300 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604210,359869,636905,417814,132380,1041138,325401,1011100,470092,796121,999193,168144,375904,967590,79448,310644,611297,927205,153550,154610,191390,579231,816550,842041,121417,868774,128397,80305,547044,795042,225555,3798,939192,144839,811675,533011,994066,183953,315551,1045317,814936,283747,738413,182194,915030,1030992,482643,273336,378910,563160,45343,881790,452575,780854,456,198923,408844,714052,153406,694053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]