SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805916 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805916 [ RunTime:0.002261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415653,389986,536926,823469,417258,762558,7553,349914,545097,631081,673597,86712,582414,528573,574810,633471,607612,62446,182452,687264,1034656,319037,185329,443650,822261,172473,589993,447276,892614,13150,396644,814221,519704,281554,591473,897680,861969,273007,950154,443916,856438,128333,507761,727576,98157,243646,398466,1007793,183177,226776,966566,665889,268609,796647,564096,873612,275320,1026415,943516,1026163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]