SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106354 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106354 [ RunTime:0.002398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226430,735230,189250,701633,301213,645108,953102,268354,125761,739286,26429,163335,877035,178511,786575,639352,602964,818636,464044,779261,92931,371210,922276,507253,698759,409372,689153,751929,282601,447916,978846,995047,716407,618374,713226,922636,951020,29440,376562,460500,634536,634436,1036460,262618,566904,386995,995636,225414,162790,166320,143939,874009,581073,583193,606262,654123,406297,579528,395803,393076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]