SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50848 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50848 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367939,97744,754839,723359,947548,292673,613992,876646,645024,46537,577281,968501,912696,496452,1043547,492033,830278,94598,38010,850794,394430,361024,574413,351588,547869,638001,868821,1048585,893794,81440,256173,756563,122105,927947,185709,587494,416329,712185,805658,91913,389935,964590,932633,228199,852580,253123,43503,778363,589233,286485,604085,1000768,875702,9206,118767,462423,891977,745046,758208,886114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]