SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532978 LIMIT 1 [ RunTime:0.002280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532978 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310728,285890,441530,9930,383570,261490,228215,456771,980995,305270,333610,973470,621705,146891,1014740,573174,985697,22249,837456,509402,75307,882211,631855,477048,788566,731537,138503,823319,595657,434347,837403,20201,899468,297097,841456,153533,461439,612042,987404,267715,26666,95105,772094,1025042,936832,792957,379772,164120,188606,803966,352581,501081,542026,82198,187050,849598,483971,550231,779780,419100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]