SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041089 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041089 [ RunTime:0.002295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135736,120100,892687,833358,565332,47150,207335,919327,159549,715436,528134,53638,975184,155803,708174,217193,114331,197807,546909,162897,231807,794777,732902,539052,167330,823353,690167,698111,12462,933289,1039849,559994,769371,910188,600597,908228,575659,289887,784034,11642,896322,206152,720160,694911,743807,325956,214732,214760,80946,31503,333164,997184,87002,84102,322502,451011,429095,15317,842095,317536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]