SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501065 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501065 [ RunTime:0.006226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65521,356120,673500,201756,60657,32992,42917,652006,891009,276545,725099,548975,779252,725918,588600,796985,57285,257630,348011,678431,955762,980197,255942,21792,334709,377926,38962,246936,719216,883666,974243,1004694,210017,821670,311805,1015390,233020,993415,629332,749446,536424,858259,1027748,895977,1025267,316321,873870,45139,1017789,896853,1045821,414810,215287,175912,440225,1000913,952770,854330,26021,675327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501065 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501065 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]