SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020012 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020012 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000717,793875,523833,1041984,548310,542118,824702,188172,774150,211898,970043,538118,215186,492364,177350,830532,401244,922400,126491,774097,318039,157529,901166,125967,144160,615439,396676,112933,982910,751346,685651,716483,1002320,268880,526370,1016140,877986,1010526,904819,229020,721538,975518,65520,1016256,833049,94150,966996,917351,603263,685261,60977,248627,380119,603419,51840,867950,41448,1041371,538205,766904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]