SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014096 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014096 [ RunTime:0.002389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909282,505978,179362,280663,647383,363123,444645,292895,680924,428083,1001572,254252,42033,645661,151559,936654,891186,239844,864608,833413,569776,814379,199551,127087,656574,529679,107055,275921,673830,534619,34293,874092,356704,695345,517207,634014,379195,124953,456669,821947,668316,67590,865738,266536,755652,22340,738478,771899,320724,102457,1046299,687794,579782,243224,130950,1019477,792315,913167,848445,3677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003526s ]