SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030136 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030136 [ RunTime:0.002242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265318,148025,657187,763783,854309,290474,324023,316702,482176,524001,148290,92007,694314,121693,325354,844695,60514,376186,1019018,766267,525721,502432,761913,186651,108877,729431,482581,840944,879485,460770,825613,800621,758932,324165,995714,115503,564647,173725,921329,18911,585182,935288,558079,110823,644358,725490,953140,831291,24360,813690,799010,400402,21274,401411,397536,905483,1037598,809629,21727,242019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]