SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036528 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036528 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162612,150652,295564,337857,646144,1030447,601377,825385,694517,805995,501571,422088,698265,645744,240523,887832,898174,288377,899612,637665,91582,25243,752349,835364,832949,693987,893418,311357,569952,954001,941829,987205,714890,236686,373527,324372,726698,786476,486385,59908,987992,56893,178900,769663,899493,534416,308558,65043,525864,278757,557147,484376,743786,876308,634481,793052,465827,67247,999098,333780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]