SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511842 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511842 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871853,421495,226622,412149,746810,659709,675210,383673,67074,553910,571586,656994,750006,224560,40398,178069,755192,804182,56806,798631,235882,999080,759963,863341,872821,904389,508844,257278,563890,318769,836639,1011481,547987,558380,552429,746944,963724,310090,903600,433642,586863,137152,54357,106560,1043876,655089,824121,350980,700957,150812,394593,351901,521964,847919,439691,804107,699876,335478,687281,807781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]