SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108204 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108204 [ RunTime:0.001404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291497,158698,164262,646528,457884,272165,93096,606380,365137,129474,148199,49111,834751,690692,64787,903656,937675,166017,37918,242610,581202,200939,1031217,708659,765893,308400,338814,287368,247923,105669,638616,729864,421202,647276,582035,439124,1037195,189724,198706,784264,206758,39401,543489,500128,203904,10070,200009,262935,137465,358572,1038054,397386,555841,1010368,883536,293347,39487,464065,941179,248489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]