SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010870 LIMIT 1 [ RunTime:0.001710s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010870 [ RunTime:0.003591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297384,546895,663304,937211,936907,422481,993281,813150,848040,617133,810557,862840,880903,667749,503366,743024,1035235,35798,200489,605242,996120,660910,792163,500953,695294,428378,489392,343877,90910,885873,584645,155594,37972,825796,869303,258674,362491,162197,302759,127207,521013,261060,444742,781540,979876,596622,429851,635780,740337,6757,551561,107906,724595,348882,812590,622708,373836,778833,497070,483091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003938s ]