SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 956418 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 956418 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008154,914309,258678,939,969295,438812,992744,46673,402415,700622,1028007,813905,400163,371162,893200,252774,774517,152450,808372,384928,799309,50222,377996,1020885,145218,278119,440467,928106,619345,428501,683871,791370,704057,742723,717201,1006051,1034786,138747,904519,178050,447849,668713,692568,237251,166601,1014978,1013305,871104,715939,75159,238780,705169,312086,761800,107089,357120,582321,761891,505707,129356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 956418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 956418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]