SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401107 LIMIT 1 [ RunTime:0.001331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401107 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474618,134400,41461,369265,825890,813954,655446,587642,46767,358246,427119,430177,943825,604789,618068,490071,636955,274658,234960,78956,73374,986820,444250,1031256,916211,568453,632019,606900,900366,38553,638215,860589,368077,859501,638385,724877,382438,796658,915321,566489,698809,246828,536152,1019613,81923,559929,550929,931263,481340,1032949,804148,674525,884225,653182,853193,628688,32623,164508,848822,124604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]