SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001960s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549741 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549741 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292693,686983,32646,301563,609350,768130,808217,593969,718702,388775,994810,364206,482893,28129,266506,195506,52948,1044625,965369,357466,747132,759063,627622,197370,152642,1003445,985723,491506,284572,731074,82111,446011,421826,811026,855672,311592,531423,11926,927598,1047811,273309,723456,745603,463068,575263,102769,955139,1010940,140903,360473,990756,15096,130283,139579,546531,385655,594855,797120,124815,443141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001027s ]