SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046248 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046248 [ RunTime:0.002088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210784,58629,75765,335868,108454,799817,545999,562889,539647,721422,317728,108083,911659,1001974,368824,682553,1020218,921894,318982,8668,882441,272973,1013130,108277,437067,519675,881431,695047,362314,1030825,1015558,58452,1014417,171370,96837,354535,964923,739618,178985,902045,891864,76130,410108,58783,372083,428545,660058,441444,18525,893949,1042271,1017975,47060,9126,808577,687444,321003,800793,493318,897429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046248 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046248 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002417s ]