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` = 534821 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534821 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263120,1036371,18652,487630,996189,390223,267444,323454,775949,20666,694204,537948,1032901,894758,900908,369180,114479,243113,820323,20063,1030245,1031887,975238,1009996,1014176,696301,453901,1024010,498605,983623,932771,311382,670361,545143,672137,502319,648276,1025525,976584,537734,777924,186635,700677,954282,817586,72699,48684,558980,320595,368914,780001,1045215,980819,304799,667314,542875,613199,599293,627071,475617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]