SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513800 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513800 [ RunTime:0.004107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502169,43414,356904,571124,319714,311235,721047,71794,37398,216408,984024,928052,303935,677708,30013,549820,451384,977422,715695,532436,627090,215920,663224,831434,864279,169366,665169,859833,634063,101350,379226,340319,489016,830407,157659,899522,1006629,546284,929459,549400,996070,71424,687314,592274,528668,800483,508937,200525,479411,62938,93021,737707,360414,905771,676876,683965,109436,1026093,229378,31607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]