SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105071 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105071 [ RunTime:0.003987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902561,387427,547406,258360,877089,916845,1000081,126251,295438,672144,796741,747032,181106,851603,270413,961147,658285,482117,355696,454136,693831,264485,117234,86224,136789,902667,1001449,312498,962820,64679,309138,67710,797890,255742,147693,552719,184433,486118,846660,476351,797768,450991,635944,978513,441723,399272,157843,824768,407321,721038,718510,63937,218596,721466,763539,616176,158947,992153,420535,424582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]