SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44805 LIMIT 1 [ RunTime:0.000749s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44805 [ RunTime:0.003525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336469,377541,1011403,815026,547077,888128,537839,898288,862164,961162,212667,295343,168426,652016,150882,10253,554391,815258,604632,862981,424927,685370,902676,429448,541947,543875,145452,832634,815293,32591,796007,726376,870877,122973,985405,1009930,775161,906654,931020,1037644,676047,193667,380627,213957,404916,120580,849776,99626,581707,537191,432420,837604,924104,14027,707699,919818,166148,1005047,545653,582294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]