SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290313 LIMIT 1 [ RunTime:0.000804s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290313 [ RunTime:0.002387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988654,133096,690404,541896,448639,904853,484957,672003,671147,52045,152774,1020708,282187,552212,599998,106731,421693,781106,100563,674288,209850,744808,435811,614847,258316,586578,402366,376751,594248,560900,185892,931,478109,599439,851642,211528,604699,670293,915057,580325,931067,538158,787792,444706,519739,550227,550579,96113,522574,493032,273317,996871,404595,649219,1045796,979599,1017714,678591,589605,844911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001840s ]